package com.chenwenxuan.sync.console.dao;

import com.chenwenxuan.sync.console.model.TaskMail;

public class TaskMailDao extends AbstractDao {
	
	public TaskMail queryTaskMail(int taskId) {
		return 
			(TaskMail) getJdbcTemplate().queryForObject
				(
					queryTaskMailSql,
					new Object[] { taskId }, 
					new RowMappers.TaskMailRowMapper()
				);
	}
	
	private String queryTaskMailSql = 
			"select TASK_ID, MSG_TEMPLATE, RECEIVER,  MSG_TITLE, \"ENABLE\" from TASK_MAIL t where t.task_id = ?";

}
